1 OVERVIEW
This project involved the utilization of Power BI to analyze a substantial dataset of terrorism attacks. The initial phase focused on data cleaning, addressing missing values and duplicate entries using the edit query feature. Subsequently, measures were calculated using built-in formulas to derive key insights and performance indicators from the dataset. The resulting Power BI dashboard provides a comprehensive visualization of the analyzed data, offering valuable insights into patterns, trends, and key metrics related to terrorism attacks.
2 Terrorism Database Description
The Terrorism Database contains information about terrorist attacks worldwide. It included details such as the date, location, attack type, weapons used, number of casualties, and responsible groups.
3 Key Findings
The total attacks from 1970 to 2017 were 182k, of the total attacks 162k attacks were successful and 20k were unsuccessful.
From 1970 to 2017, 412 000 people were killed and 524 000 were wounded.
From 1970 to 2017, the total ransom paid to terrorists was $556 million and 51 000 people were released.
Middle East and North Africa has the largest number of people killed (137 642) and people wounded (214 308) followed by South Asia (141 360 people wounded and 101 319 people killed). These are the most two regions affected.
Over the years (1970 to 2017), terrorists used two types of attacks and type 1 attack dominated throughout the period. Type 1 attacks consisted of Armed Assaults, Assassinations, Bombing/Explosion, Facility Attack, Hijacking, Hostage taking, Kidnapping and Unarmed Assault.
Terrorists mostly used explosive weapons to attack and kill people.
Iraq is the most affected country with a total count of 24.64k attacks followed by Pakistan with 14.37k attacks
4 Summary
The impact of terrorism is likely to decrease over the years because in 2015 there were 16k attacks and 39k people were killed, in 2016 there were 14k attacks and 35k people were killed but in 2017 there were 11k attacks and 26k people were killed showing a sharp decrease in both attacks and people killed. These insights highlight the complexity and evolving nature of global terrorism as well as the efforts and initiatives aimed at understanding, preventing and countering terrorist activities on a global scale.